Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.7 MiB |
| Average record size in memory | 278.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Text | 1 |
| Numeric | 8 |
| Categorical | 4 |
Number_of_Claims has 3663 (36.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-10-26 14:15:04.015827 |
|---|---|
| Analysis finished | 2024-10-26 14:15:09.665480 |
| Duration | 5.65 seconds |
| Software version | ydata-profiling vv4.11.0 |
| Download configuration | config.json |
Variables
Date
Date
| Distinct | 1096 |
|---|---|
| Distinct (%) | 11.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2023-01-01 00:00:00 |
Policy_ID
Text
| Distinct | 500 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 566.5 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | POL000353 |
|---|---|
| 2nd row | POL000416 |
| 3rd row | POL000200 |
| 4th row | POL000109 |
| 5th row | POL000327 |
| Value | Count | Frequency (%) |
| pol000323 | 36 | 0.4% |
| pol000077 | 34 | 0.3% |
| pol000245 | 32 | 0.3% |
| pol000005 | 32 | 0.3% |
| pol000336 | 31 | 0.3% |
| pol000471 | 31 | 0.3% |
| pol000034 | 31 | 0.3% |
| pol000084 | 31 | 0.3% |
| pol000010 | 30 | 0.3% |
| pol000078 | 30 | 0.3% |
| Other values (490) | 9682 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34041 | |
| P | 10000 | 11.1% |
| O | 10000 | 11.1% |
| L | 10000 | 11.1% |
| 4 | 4053 | 4.5% |
| 3 | 3971 | 4.4% |
| 1 | 3970 | 4.4% |
| 2 | 3946 | 4.4% |
| 6 | 2066 | 2.3% |
| 5 | 2010 | 2.2% |
| Other values (3) | 5943 | 6.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34041 | |
| P | 10000 | 11.1% |
| O | 10000 | 11.1% |
| L | 10000 | 11.1% |
| 4 | 4053 | 4.5% |
| 3 | 3971 | 4.4% |
| 1 | 3970 | 4.4% |
| 2 | 3946 | 4.4% |
| 6 | 2066 | 2.3% |
| 5 | 2010 | 2.2% |
| Other values (3) | 5943 | 6.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34041 | |
| P | 10000 | 11.1% |
| O | 10000 | 11.1% |
| L | 10000 | 11.1% |
| 4 | 4053 | 4.5% |
| 3 | 3971 | 4.4% |
| 1 | 3970 | 4.4% |
| 2 | 3946 | 4.4% |
| 6 | 2066 | 2.3% |
| 5 | 2010 | 2.2% |
| Other values (3) | 5943 | 6.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34041 | |
| P | 10000 | 11.1% |
| O | 10000 | 11.1% |
| L | 10000 | 11.1% |
| 4 | 4053 | 4.5% |
| 3 | 3971 | 4.4% |
| 1 | 3970 | 4.4% |
| 2 | 3946 | 4.4% |
| 6 | 2066 | 2.3% |
| 5 | 2010 | 2.2% |
| Other values (3) | 5943 | 6.6% |
Premium_Amount
Real number (ℝ)
| Distinct | 9125 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 498.4197 |
| Minimum | -57.18 |
|---|---|
| Maximum | 1045.76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | -57.18 |
|---|---|
| 5-th percentile | 251.8945 |
| Q1 | 397.815 |
| median | 498.41 |
| Q3 | 598.2675 |
| 95-th percentile | 744.6115 |
| Maximum | 1045.76 |
| Range | 1102.94 |
| Interquartile range (IQR) | 200.4525 |
Descriptive statistics
| Standard deviation | 149.38995 |
|---|---|
| Coefficient of variation (CV) | 0.29972721 |
| Kurtosis | -0.052908867 |
| Mean | 498.4197 |
| Median Absolute Deviation (MAD) | 100.325 |
| Skewness | 0.028886735 |
| Sum | 4984197 |
| Variance | 22317.356 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 483.63 | 4 | < 0.1% |
| 541.12 | 4 | < 0.1% |
| 505.3 | 4 | < 0.1% |
| 511.09 | 4 | < 0.1% |
| 469.06 | 4 | < 0.1% |
| 634.71 | 4 | < 0.1% |
| 457.14 | 4 | < 0.1% |
| 531.17 | 4 | < 0.1% |
| 610.19 | 3 | < 0.1% |
| 507.73 | 3 | < 0.1% |
| Other values (9115) | 9962 |
| Value | Count | Frequency (%) |
| -57.18 | 1 | |
| -0.49 | 1 | |
| 21.43 | 1 | |
| 24.55 | 1 | |
| 27.89 | 1 | |
| 35.55 | 1 | |
| 46.83 | 1 | |
| 53.78 | 1 | |
| 58.57 | 1 | |
| 58.58 | 1 |
| Value | Count | Frequency (%) |
| 1045.76 | 1 | |
| 1025.58 | 1 | |
| 1020.44 | 1 | |
| 1006.21 | 1 | |
| 1004.82 | 1 | |
| 982.37 | 1 | |
| 976.51 | 1 | |
| 971.6 | 1 | |
| 970.78 | 1 | |
| 968.33 | 1 |
Claim_Amount
Real number (ℝ)
| Distinct | 8918 |
|---|---|
| Distinct (%) | 89.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201.17143 |
| Minimum | 0.05 |
|---|---|
| Maximum | 2399.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 10.8795 |
| Q1 | 57.8725 |
| median | 141.2 |
| Q3 | 276.555 |
| 95-th percentile | 605.889 |
| Maximum | 2399.2 |
| Range | 2399.15 |
| Interquartile range (IQR) | 218.6825 |
Descriptive statistics
| Standard deviation | 199.29359 |
|---|---|
| Coefficient of variation (CV) | 0.99066548 |
| Kurtosis | 5.7721976 |
| Mean | 201.17143 |
| Median Absolute Deviation (MAD) | 97.205 |
| Skewness | 1.9306526 |
| Sum | 2011714.2 |
| Variance | 39717.933 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.16 | 4 | < 0.1% |
| 22.72 | 4 | < 0.1% |
| 44.43 | 4 | < 0.1% |
| 215.81 | 4 | < 0.1% |
| 34.32 | 3 | < 0.1% |
| 18.61 | 3 | < 0.1% |
| 50.56 | 3 | < 0.1% |
| 16.29 | 3 | < 0.1% |
| 12.16 | 3 | < 0.1% |
| 6.36 | 3 | < 0.1% |
| Other values (8908) | 9966 |
| Value | Count | Frequency (%) |
| 0.05 | 1 | < 0.1% |
| 0.08 | 2 | |
| 0.16 | 4 | |
| 0.17 | 3 | |
| 0.2 | 1 | < 0.1% |
| 0.22 | 1 | < 0.1% |
| 0.23 | 1 | < 0.1% |
| 0.26 | 1 | < 0.1% |
| 0.27 | 1 | < 0.1% |
| 0.29 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2399.2 | 1 | |
| 1637.57 | 1 | |
| 1631.09 | 1 | |
| 1499.82 | 1 | |
| 1456.28 | 1 | |
| 1371.51 | 1 | |
| 1355.19 | 1 | |
| 1349.56 | 1 | |
| 1338.12 | 1 | |
| 1333.63 | 1 |
Number_of_Claims
Real number (ℝ)
Zeros 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0002 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 3663 |
| Zeros (%) | 36.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.0010495 |
|---|---|
| Coefficient of variation (CV) | 1.0008494 |
| Kurtosis | 1.0473046 |
| Mean | 1.0002 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.0196917 |
| Sum | 10002 |
| Variance | 1.0021002 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 3716 | |
| 0 | 3663 | |
| 2 | 1828 | |
| 3 | 588 | 5.9% |
| 4 | 163 | 1.6% |
| 5 | 39 | 0.4% |
| 6 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 3663 | |
| 1 | 3716 | |
| 2 | 1828 | |
| 3 | 588 | 5.9% |
| 4 | 163 | 1.6% |
| 5 | 39 | 0.4% |
| 6 | 2 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 6 | 2 | < 0.1% |
| 5 | 39 | 0.4% |
| 4 | 163 | 1.6% |
| 3 | 588 | 5.9% |
| 2 | 1828 | |
| 1 | 3716 | |
| 0 | 3663 |
Policy_Type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 524.2 KiB |
| Life | |
|---|---|
| Health | |
| Auto |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.6636 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Health |
|---|---|
| 2nd row | Auto |
| 3rd row | Life |
| 4th row | Auto |
| 5th row | Auto |
Common Values
| Value | Count | Frequency (%) |
| Life | 3384 | |
| Health | 3318 | |
| Auto | 3298 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| life | 3384 | |
| health | 3318 | |
| auto | 3298 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 6702 | |
| t | 6616 | |
| L | 3384 | |
| i | 3384 | |
| f | 3384 | |
| H | 3318 | |
| a | 3318 | |
| l | 3318 | |
| h | 3318 | |
| A | 3298 | |
| Other values (2) | 6596 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 46636 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 6702 | |
| t | 6616 | |
| L | 3384 | |
| i | 3384 | |
| f | 3384 | |
| H | 3318 | |
| a | 3318 | |
| l | 3318 | |
| h | 3318 | |
| A | 3298 | |
| Other values (2) | 6596 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 46636 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 6702 | |
| t | 6616 | |
| L | 3384 | |
| i | 3384 | |
| f | 3384 | |
| H | 3318 | |
| a | 3318 | |
| l | 3318 | |
| h | 3318 | |
| A | 3298 | |
| Other values (2) | 6596 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 46636 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 6702 | |
| t | 6616 | |
| L | 3384 | |
| i | 3384 | |
| f | 3384 | |
| H | 3318 | |
| a | 3318 | |
| l | 3318 | |
| h | 3318 | |
| A | 3298 | |
| Other values (2) | 6596 |
Policy_Status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 550.3 KiB |
| Expired | |
|---|---|
| Cancelled | |
| Active |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.3345 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Expired |
|---|---|
| 2nd row | Expired |
| 3rd row | Cancelled |
| 4th row | Cancelled |
| 5th row | Cancelled |
Common Values
| Value | Count | Frequency (%) |
| Expired | 3382 | |
| Cancelled | 3321 | |
| Active | 3297 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| expired | 3382 | |
| cancelled | 3321 | |
| active | 3297 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13321 | |
| d | 6703 | |
| i | 6679 | |
| l | 6642 | |
| c | 6618 | |
| E | 3382 | 4.6% |
| x | 3382 | 4.6% |
| p | 3382 | 4.6% |
| r | 3382 | 4.6% |
| C | 3321 | 4.5% |
| Other values (5) | 16533 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 73345 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 13321 | |
| d | 6703 | |
| i | 6679 | |
| l | 6642 | |
| c | 6618 | |
| E | 3382 | 4.6% |
| x | 3382 | 4.6% |
| p | 3382 | 4.6% |
| r | 3382 | 4.6% |
| C | 3321 | 4.5% |
| Other values (5) | 16533 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 73345 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 13321 | |
| d | 6703 | |
| i | 6679 | |
| l | 6642 | |
| c | 6618 | |
| E | 3382 | 4.6% |
| x | 3382 | 4.6% |
| p | 3382 | 4.6% |
| r | 3382 | 4.6% |
| C | 3321 | 4.5% |
| Other values (5) | 16533 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 73345 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 13321 | |
| d | 6703 | |
| i | 6679 | |
| l | 6642 | |
| c | 6618 | |
| E | 3382 | 4.6% |
| x | 3382 | 4.6% |
| p | 3382 | 4.6% |
| r | 3382 | 4.6% |
| C | 3321 | 4.5% |
| Other values (5) | 16533 |
Customer_Age
Real number (ℝ)
| Distinct | 57 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.1496 |
| Minimum | 18 |
|---|---|
| Maximum | 74 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 32 |
| median | 46 |
| Q3 | 60 |
| 95-th percentile | 72 |
| Maximum | 74 |
| Range | 56 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 16.51453 |
|---|---|
| Coefficient of variation (CV) | 0.35784773 |
| Kurtosis | -1.2054265 |
| Mean | 46.1496 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -0.0098044439 |
| Sum | 461496 |
| Variance | 272.72969 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 60 | 201 | 2.0% |
| 45 | 193 | 1.9% |
| 67 | 192 | 1.9% |
| 23 | 192 | 1.9% |
| 34 | 191 | 1.9% |
| 49 | 191 | 1.9% |
| 65 | 191 | 1.9% |
| 58 | 189 | 1.9% |
| 30 | 188 | 1.9% |
| 74 | 187 | 1.9% |
| Other values (47) | 8085 |
| Value | Count | Frequency (%) |
| 18 | 187 | |
| 19 | 177 | |
| 20 | 168 | |
| 21 | 172 | |
| 22 | 169 | |
| 23 | 192 | |
| 24 | 149 | |
| 25 | 178 | |
| 26 | 180 | |
| 27 | 162 |
| Value | Count | Frequency (%) |
| 74 | 187 | |
| 73 | 182 | |
| 72 | 175 | |
| 71 | 182 | |
| 70 | 182 | |
| 69 | 173 | |
| 68 | 175 | |
| 67 | 192 | |
| 66 | 172 | |
| 65 | 191 |
Customer_Gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 527.4 KiB |
| Male | |
|---|---|
| Female |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.9914 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Female |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Female |
Common Values
| Value | Count | Frequency (%) |
| Male | 5043 | |
| Female | 4957 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 5043 | |
| female | 4957 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 14957 | |
| a | 10000 | |
| l | 10000 | |
| M | 5043 | 10.1% |
| F | 4957 | 9.9% |
| m | 4957 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49914 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 14957 | |
| a | 10000 | |
| l | 10000 | |
| M | 5043 | 10.1% |
| F | 4957 | 9.9% |
| m | 4957 | 9.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49914 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 14957 | |
| a | 10000 | |
| l | 10000 | |
| M | 5043 | 10.1% |
| F | 4957 | 9.9% |
| m | 4957 | 9.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49914 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 14957 | |
| a | 10000 | |
| l | 10000 | |
| M | 5043 | 10.1% |
| F | 4957 | 9.9% |
| m | 4957 | 9.9% |
Renewal_Probability
Real number (ℝ)
| Distinct | 101 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.498111 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 52 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.05 |
| Q1 | 0.25 |
| median | 0.5 |
| Q3 | 0.75 |
| 95-th percentile | 0.95 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.28816014 |
|---|---|
| Coefficient of variation (CV) | 0.57850587 |
| Kurtosis | -1.1950532 |
| Mean | 0.498111 |
| Median Absolute Deviation (MAD) | 0.25 |
| Skewness | 0.0066087112 |
| Sum | 4981.11 |
| Variance | 0.083036265 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.85 | 123 | 1.2% |
| 0.39 | 121 | 1.2% |
| 0.26 | 118 | 1.2% |
| 0.4 | 117 | 1.2% |
| 0.6 | 116 | 1.2% |
| 0.18 | 116 | 1.2% |
| 0.55 | 115 | 1.1% |
| 0.83 | 113 | 1.1% |
| 0.05 | 113 | 1.1% |
| 0.81 | 113 | 1.1% |
| Other values (91) | 8835 |
| Value | Count | Frequency (%) |
| 0 | 52 | |
| 0.01 | 96 | |
| 0.02 | 92 | |
| 0.03 | 110 | |
| 0.04 | 87 | |
| 0.05 | 113 | |
| 0.06 | 106 | |
| 0.07 | 110 | |
| 0.08 | 106 | |
| 0.09 | 97 |
| Value | Count | Frequency (%) |
| 1 | 58 | |
| 0.99 | 98 | |
| 0.98 | 98 | |
| 0.97 | 101 | |
| 0.96 | 106 | |
| 0.95 | 80 | |
| 0.94 | 85 | |
| 0.93 | 92 | |
| 0.92 | 101 | |
| 0.91 | 85 |
Risk_Score
Real number (ℝ)
| Distinct | 101 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49.999 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 100 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 25 |
| median | 50 |
| Q3 | 75.25 |
| 95-th percentile | 96 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 50.25 |
Descriptive statistics
| Standard deviation | 29.205717 |
|---|---|
| Coefficient of variation (CV) | 0.58412602 |
| Kurtosis | -1.2028252 |
| Mean | 49.999 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | -0.003790661 |
| Sum | 499990 |
| Variance | 852.9739 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 65 | 121 | 1.2% |
| 87 | 119 | 1.2% |
| 55 | 118 | 1.2% |
| 10 | 118 | 1.2% |
| 51 | 117 | 1.2% |
| 79 | 116 | 1.2% |
| 27 | 115 | 1.1% |
| 80 | 114 | 1.1% |
| 97 | 114 | 1.1% |
| 28 | 111 | 1.1% |
| Other values (91) | 8837 |
| Value | Count | Frequency (%) |
| 0 | 100 | |
| 1 | 106 | |
| 2 | 86 | |
| 3 | 103 | |
| 4 | 104 | |
| 5 | 103 | |
| 6 | 101 | |
| 7 | 100 | |
| 8 | 96 | |
| 9 | 96 |
| Value | Count | Frequency (%) |
| 100 | 86 | |
| 99 | 97 | |
| 98 | 106 | |
| 97 | 114 | |
| 96 | 99 | |
| 95 | 106 | |
| 94 | 91 | |
| 93 | 103 | |
| 92 | 101 | |
| 91 | 82 |
Customer_Loyalty_Score
Real number (ℝ)
| Distinct | 101 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.1126 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 82 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 25 |
| median | 50 |
| Q3 | 75 |
| 95-th percentile | 95 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 50 |
Descriptive statistics
| Standard deviation | 29.030363 |
|---|---|
| Coefficient of variation (CV) | 0.57930268 |
| Kurtosis | -1.1927099 |
| Mean | 50.1126 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | 0.0057560895 |
| Sum | 501126 |
| Variance | 842.762 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 32 | 133 | 1.3% |
| 99 | 127 | 1.3% |
| 47 | 120 | 1.2% |
| 26 | 119 | 1.2% |
| 93 | 118 | 1.2% |
| 34 | 117 | 1.2% |
| 83 | 115 | 1.1% |
| 4 | 113 | 1.1% |
| 12 | 113 | 1.1% |
| 15 | 113 | 1.1% |
| Other values (91) | 8812 |
| Value | Count | Frequency (%) |
| 0 | 82 | |
| 1 | 82 | |
| 2 | 83 | |
| 3 | 107 | |
| 4 | 113 | |
| 5 | 101 | |
| 6 | 105 | |
| 7 | 98 | |
| 8 | 89 | |
| 9 | 104 |
| Value | Count | Frequency (%) |
| 100 | 95 | |
| 99 | 127 | |
| 98 | 96 | |
| 97 | 89 | |
| 96 | 91 | |
| 95 | 97 | |
| 94 | 102 | |
| 93 | 118 | |
| 92 | 101 | |
| 91 | 87 |
Year
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 517.7 KiB |
| 2022 | |
|---|---|
| 2021 | |
| 2020 | |
| 2023 | 6 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2020 |
|---|---|
| 2nd row | 2020 |
| 3rd row | 2020 |
| 4th row | 2020 |
| 5th row | 2020 |
Common Values
| Value | Count | Frequency (%) |
| 2022 | 3358 | |
| 2021 | 3340 | |
| 2020 | 3296 | |
| 2023 | 6 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022 | 3358 | |
| 2021 | 3340 | |
| 2020 | 3296 | |
| 2023 | 6 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 23358 | |
| 0 | 13296 | |
| 1 | 3340 | 8.3% |
| 3 | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 23358 | |
| 0 | 13296 | |
| 1 | 3340 | 8.3% |
| 3 | 6 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 23358 | |
| 0 | 13296 | |
| 1 | 3340 | 8.3% |
| 3 | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 23358 | |
| 0 | 13296 | |
| 1 | 3340 | 8.3% |
| 3 | 6 | < 0.1% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5615 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 39.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4747986 |
|---|---|
| Coefficient of variation (CV) | 0.52957381 |
| Kurtosis | -1.2224473 |
| Mean | 6.5615 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.029600456 |
| Sum | 65615 |
| Variance | 12.074225 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 887 | |
| 1 | 885 | |
| 7 | 885 | |
| 12 | 869 | |
| 3 | 864 | |
| 11 | 859 | |
| 8 | 828 | |
| 5 | 819 | |
| 4 | 796 | |
| 9 | 791 | |
| Other values (2) | 1517 |
| Value | Count | Frequency (%) |
| 1 | 885 | |
| 2 | 732 | |
| 3 | 864 | |
| 4 | 796 | |
| 5 | 819 | |
| 6 | 785 | |
| 7 | 885 | |
| 8 | 828 | |
| 9 | 791 | |
| 10 | 887 |
| Value | Count | Frequency (%) |
| 12 | 869 | |
| 11 | 859 | |
| 10 | 887 | |
| 9 | 791 | |
| 8 | 828 | |
| 7 | 885 | |
| 6 | 785 | |
| 5 | 819 | |
| 4 | 796 | |
| 3 | 864 |
Interactions
Correlations
| Claim_Amount | Customer_Age | Customer_Gender | Customer_Loyalty_Score | Month | Number_of_Claims | Policy_Status | Policy_Type | Premium_Amount | Renewal_Probability | Risk_Score | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Claim_Amount | 1.000 | 0.001 | 0.000 | 0.012 | -0.002 | 0.002 | 0.008 | 0.007 | -0.013 | -0.009 | 0.001 | 0.005 |
| Customer_Age | 0.001 | 1.000 | 0.016 | 0.001 | 0.003 | -0.005 | 0.001 | 0.034 | -0.014 | 0.001 | 0.001 | 0.000 |
| Customer_Gender | 0.000 | 0.016 | 1.000 | 0.000 | 0.018 | 0.000 | 0.012 | 0.006 | 0.017 | 0.000 | 0.024 | 0.010 |
| Customer_Loyalty_Score | 0.012 | 0.001 | 0.000 | 1.000 | -0.009 | 0.005 | 0.004 | 0.000 | -0.018 | 0.008 | 0.011 | 0.006 |
| Month | -0.002 | 0.003 | 0.018 | -0.009 | 1.000 | 0.007 | 0.000 | 0.016 | 0.011 | -0.005 | -0.010 | 0.020 |
| Number_of_Claims | 0.002 | -0.005 | 0.000 | 0.005 | 0.007 | 1.000 | 0.017 | 0.007 | 0.002 | -0.001 | -0.010 | 0.000 |
| Policy_Status | 0.008 | 0.001 | 0.012 | 0.004 | 0.000 | 0.017 | 1.000 | 0.000 | 0.020 | 0.005 | 0.020 | 0.010 |
| Policy_Type | 0.007 | 0.034 | 0.006 | 0.000 | 0.016 | 0.007 | 0.000 | 1.000 | 0.004 | 0.000 | 0.020 | 0.000 |
| Premium_Amount | -0.013 | -0.014 | 0.017 | -0.018 | 0.011 | 0.002 | 0.020 | 0.004 | 1.000 | 0.010 | -0.013 | 0.019 |
| Renewal_Probability | -0.009 | 0.001 | 0.000 | 0.008 | -0.005 | -0.001 | 0.005 | 0.000 | 0.010 | 1.000 | 0.010 | 0.012 |
| Risk_Score | 0.001 | 0.001 | 0.024 | 0.011 | -0.010 | -0.010 | 0.020 | 0.020 | -0.013 | 0.010 | 1.000 | 0.000 |
| Year | 0.005 | 0.000 | 0.010 | 0.006 | 0.020 | 0.000 | 0.010 | 0.000 | 0.019 | 0.012 | 0.000 | 1.000 |
Missing values
Sample
| Date | Policy_ID | Premium_Amount | Claim_Amount | Number_of_Claims | Policy_Type | Policy_Status | Customer_Age | Customer_Gender | Renewal_Probability | Risk_Score | Customer_Loyalty_Score | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2020-01-01 | POL000353 | 358.29 | 271.21 | 2 | Health | Expired | 19 | Male | 0.14 | 9 | 69 | 2020 | 1 |
| 1 | 2020-01-01 | POL000416 | 243.78 | 14.70 | 2 | Auto | Expired | 33 | Female | 0.93 | 54 | 85 | 2020 | 1 |
| 2 | 2020-01-01 | POL000200 | 301.74 | 70.46 | 0 | Life | Cancelled | 68 | Male | 0.19 | 45 | 37 | 2020 | 1 |
| 3 | 2020-01-01 | POL000109 | 491.45 | 424.61 | 1 | Auto | Cancelled | 57 | Male | 0.35 | 92 | 19 | 2020 | 1 |
| 4 | 2020-01-01 | POL000327 | 429.26 | 420.43 | 0 | Auto | Cancelled | 43 | Female | 0.08 | 7 | 99 | 2020 | 1 |
| 5 | 2020-01-01 | POL000234 | 654.58 | 154.80 | 2 | Life | Active | 32 | Male | 0.89 | 18 | 26 | 2020 | 1 |
| 6 | 2020-01-01 | POL000403 | 684.50 | 619.11 | 0 | Auto | Expired | 67 | Male | 0.97 | 12 | 95 | 2020 | 1 |
| 7 | 2020-01-01 | POL000431 | 316.77 | 228.56 | 0 | Health | Cancelled | 64 | Female | 0.41 | 49 | 59 | 2020 | 1 |
| 8 | 2020-01-01 | POL000294 | 522.08 | 189.64 | 1 | Life | Cancelled | 42 | Male | 0.12 | 65 | 80 | 2020 | 1 |
| 9 | 2020-01-01 | POL000362 | 501.04 | 162.31 | 1 | Health | Active | 67 | Female | 0.37 | 48 | 20 | 2020 | 1 |
| Date | Policy_ID | Premium_Amount | Claim_Amount | Number_of_Claims | Policy_Type | Policy_Status | Customer_Age | Customer_Gender | Renewal_Probability | Risk_Score | Customer_Loyalty_Score | Year | Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | 2022-12-31 | POL000288 | 511.60 | 167.76 | 0 | Auto | Expired | 69 | Male | 0.71 | 77 | 85 | 2022 | 12 |
| 9991 | 2022-12-31 | POL000233 | 359.25 | 1115.80 | 0 | Health | Active | 56 | Male | 0.27 | 79 | 47 | 2022 | 12 |
| 9992 | 2022-12-31 | POL000381 | 510.92 | 142.36 | 0 | Auto | Active | 68 | Male | 0.05 | 34 | 33 | 2022 | 12 |
| 9993 | 2022-12-31 | POL000061 | 423.05 | 835.56 | 1 | Life | Active | 43 | Male | 0.07 | 10 | 4 | 2022 | 12 |
| 9994 | 2023-01-01 | POL000349 | 399.50 | 604.10 | 0 | Auto | Cancelled | 58 | Male | 0.55 | 47 | 78 | 2023 | 1 |
| 9995 | 2023-01-01 | POL000274 | 452.99 | 169.04 | 3 | Life | Active | 20 | Male | 0.70 | 25 | 84 | 2023 | 1 |
| 9996 | 2023-01-01 | POL000162 | 619.28 | 315.72 | 1 | Health | Cancelled | 47 | Male | 0.29 | 46 | 71 | 2023 | 1 |
| 9997 | 2023-01-01 | POL000247 | 480.68 | 20.67 | 1 | Life | Expired | 55 | Female | 0.63 | 100 | 22 | 2023 | 1 |
| 9998 | 2023-01-01 | POL000436 | 342.79 | 266.50 | 0 | Auto | Cancelled | 25 | Male | 0.78 | 63 | 100 | 2023 | 1 |
| 9999 | 2023-01-01 | POL000473 | 440.46 | 67.78 | 2 | Auto | Cancelled | 55 | Female | 0.79 | 3 | 13 | 2023 | 1 |